﻿CREATE TABLE [dbo].[Files] (
    [fileID]         UNIQUEIDENTIFIER NOT NULL,
    [fileTypeID]     SMALLINT         NOT NULL,
    [patientID]      BIGINT           NULL,
    [fileName]       NVARCHAR (300)   NOT NULL,
    [fileSizeBytes]  INT              NOT NULL,
    [fileUploadDate] DATETIME         NOT NULL
);

